Using Master and Detail sections to display records
When you create a query that contains more than one table, Results automatically displays all the fields from the tables in one section. To help you analyze data, you can separate the information contained in these tables into two sections, called Master and Detail.
For example, if your query uses fields from the Customer, Order, and Order-Line tables to list the items each customer ordered, Results places the records in one section by default, as in the Figure 6–1.
In this example, the query retrieves a record for each item number within each order. Many of the records contain identical information. To reduce the amount of repetitive information displayed in the view, you can split the view into two sections, Master and Detail. A Master section begins a new order and its corresponding Detail section contains the specific items ordered. You can use the Master-Detail option with the Browse, Report, and Form query views.
Splitting composite records into Master and Detail sections does not alter the way in which the query retrieves the records. as the example query view shows in Figure 6–2, it simply alters the way in which Results displays the records within the query view.
In Figure 6–2, the Master section contains fields from the Customer and Order tables and the Detail section contains fields from the Order-Line table.
|
To split composite records into Master and Detail sections: |
- Choose Options
Master-Detail. The Master-Detail dialog box appears: - Determine how you want to split the tables, then select a break point and choose OK.
When you split composite records into Master and Detail sections the Form or Browse views, Results automatically places each section in its own frame. See the "Browse view" section and "Form view" section for more information about frames.